Winchester

select * from tb_web_taxonomy with (nolock) where upper(web_url)=? and site = 'sportsman'

SELECT distinct b.style_id
    FROM tb_term_sale_entries b with (nolock) LEFT JOIN tb_term_sales a with (nolock) ON (a.term_sale_id=b.term_sale_id)
    WHERE b.start_date<= '2024-05-20 15:00:00' AND b.end_date >= '2024-05-20 15:00:00' AND b.store_id=10

SELECT * 
	FROM tb_mfg_promo.dbo.tb_pkg a with (nolock)
	INNER JOIN tb_mfg_promo.dbo.tb_pkg_main_items b WITH (NOLOCK)
		ON (a.pkg_id = b.pkg_id) 
	WHERE 
	b.main_id is not NULL 
	and a.start_date<= '05/20/2024 23:59:00' and a.end_date >= '05/20/2024'
	
	and a.site='sportsman'

select * from tb_mfg_promo.dbo.BULK_ITM_DSCS with (nolock)

SELECT a.styles_web_taxonomy_id,max(a.style_id) as style_id,max(a.style) as style,max(a.web_style) as web_style,max(a.description) as web_desc,max(a.web_desc) as web_description,max(a.web_long_desc) as web_long_desc,max(a.picture_id) as picture_id,max(a.sort_position) as prod_sort_position,max(a.dept) as dept,max(a.typ) as typ,max(a.subtyp_1) as subtyp_1,max(a.subtyp_2) as subtyp_2,max(a.subtyp_3) as subtyp_3,max(a.category_style) as category_style,max(a.web_url) as web_url,max(a.sort_position) as sort_position,max(a.web_taxonomy_id) as web_taxonomy_id,max(a.brand) as brand,max(a.date_entered) as date_entered,max(a.non_invt) as non_invt,max(a.overnight_required) as overnight_required,max(a.is_firearm) as is_firearm,max(a.of1) as of1,max(a.of2) as of2,max(a.of3) as of3,max(a.of4) as of4,max(a.of5) as of5,max(a.of6) as of6,max(a.of7) as of7,max(a.of8) as of8,max(a.of9) as of9,max(a.of10) as of10,max(a.of11) as of11,max(a.of12) as of12,max(a.of13) as of13,max(a.of14) as of14,max(a.of15) as of15,max(a.of16) as of16,max(a.of17) as of17,max(a.of18) as of18,max(a.of19) as of19,max(a.of20) as of20
,min(c.price) as min_price,min(c.store_price) as store_price,max(c.sugg_price) as max_price,min(c.wholesale_price) as vipprice,max(c.qoh) as qoh,max(c.qc) as qc,max(c.qs) as qs,sum(qoh + qc) as available,sum(c.qs - c.qc) as sold,max(c.sugg_price) AS max_sugg_price,avg(CASE WHEN qq.of9 IS NULL OR qq.of9 = '' THEN 0 ELSE c.price / qq.of9 END) as round
	
 FROM web_all_products a WITH (NOLOCK)
 INNER JOIN dbo.tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
 INNER JOIN dbo.tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
 INNER JOIN dbo.tb_styles_web_taxonomy d WITH (NOLOCK) ON (a.style_id = d.style)
 INNER JOIN dbo.tb_styles qq WITH (NOLOCK) ON (qq.style_id = a.style_id)
	
	
 WHERE a.style_id > 0 and (a.of20='SPORTS' or a.of20='BOTH' or a.of20 = 'SPORTSOUTDOORS') and a.picture_id > 0
and qq.web_product='Y' and c.store_id=10 
	 and a.brand='WINCHESTER AMMO'
	
	group by a.styles_web_taxonomy_id

select
		distinct
		(style_id) as style_id
		, max(picture_id)
			,	min(min_price) as min_price
			,	max(max_price) as max_price
			,	min(vipprice) as vipprice
			,	max(web_style) as web_style
            ,	max(style) as style
			,	max(web_desc) as web_desc
            ,	max(web_description) as web_description
			,	max(picture_id) as picture_id
            ,	max(web_long_desc) as web_long_desc
			,   max(dept) as dept
			,   max(qoh) as qoh
			,	max(qc) as qc
			,	max(qs) as qs
			,	max(of18) as of18
			,	max(of17) as of17
			,	max(of15) as of15
            ,	max(of12) as of12
    		,	max(of10) as of10
    		,	max(of9) as of9
    		,	max(of8) as of8
			,	max(of7) as of7
    		,	max(of6) as of6
    		,	max(of5) as of5
            ,	max(of4) as of4
    		,	max(of3) as of3
            ,	max(of2) as of2
            ,	max(of1) as of1
			,	max(available) as available
            ,	max(available) as sold
			,   max(typ) as typ
            ,	max(round) as round
            ,	max(non_invt) as non_invt
			,	max(overnight_required) as overnight_required
			,   max(subtyp_1) as subtyp_1
			,   max(subtyp_2) as subtyp_2
			,   max(subtyp_3) as subtyp_3
			,   max(category_style) as category_style
		     ,   max(sort_position) as sort_position
		     ,max(brand) as brand
	,	MAX(max_sugg_price) AS max_sugg_price
    

		from grandgetproducts
		where
		 style_id is not null
            
				and brand='WINCHESTER AMMO'
			


group by Style_id order by

 	available desc, non_invt desc

select * from grandgetproducts
		where
		 picture_id is not null
            
			
				and brand='WINCHESTER AMMO'
			


order by

min_price

select dept, web_url ,sort_position, category_style from tb_web_taxonomy with (nolock) where typ='EMPTY' and dept<>'EMPTY' and dept='' and site = 'sportsman' order by sort_position

select distinct(brand) as brand from GetProducts

select distinct a.spec_value from tb_mfg_promo.dbo.item_spec_values a left join tb_mfg_promo.dbo.item_spec_names b on (a.spec_id=b.spec_id) left join tb_mfg_promo.dbo.item_specs c on (a.spec_value_id=c.spec_value_id) where b.spec_name = 'Product Line' and c.style_id in (217370,172271,204264,249454,199109,271776,61293,72688,127973,168795,298396,286697,256887,248328,72706,137599,61122,179833,61129,253425,161439,61417,304633,61294,253420,61396,162081,61943,169080,61472,102772,61418,61119,61945,175663,249451,61423,175667,248329,61355,114866,251197,266656,310056,310070,310071,310068,61220,199111,61968,204293,61328,129145,61426,61921,277298,61433,61874,61946,284144,61405,216839,216826,307980,137064,199107,61377,175664,285611,61379,61482,215089,61403,61431,74855,204294,61495,61357,61380,61481,61504,61875,61951,61967,127835,129290,204326,285128,61123,61131,61479,61810,61929,74026,199110,61080,61081,61111,61112,61113,61114,61118,61124,61125,61126,61127,61128,61130,61132,61133,61134,61136,61137,61139,61140,61142,61143,61144,61145,61146,61147,61148,61150,61153,61154,61155,61156,61157,61158,61161,61162,61163,61166,61167,61168,61169,61170,61172,61173,61175,61176,61177,61178,61184,61188,61195,61208,61216,61217,61219,61221,61225,61226,61228,61229,61230,61232,61237,61238,61239,61242,61267,61268,61269,61279,61280,61281,61285,61287,61288,61289,61290,61291,61292,61296,61299,61300,61301,61302,61303,61315,61317,61318,61319,61320,61321,61322,61324,61325,61326,61332,61334,61338,61343,61345,61348,61350,61353,61358,61359,61360,61362,61364,61365,61366,61367,61374,61375,61376,61378,61381,61382,61383,61384,61385,61386,61389,61391,61393,61394,61395,61397,61400,61402,61404,61410,61412,61419,61421,61424,61427,61429,61430,61435,61438,61439,61440,61442,61443,61445,61446,61447,61448,61449,61450,61451,61453,61454,61455,61458,61459,61460,61462,61463,61464,61465,61467,61468,61469,61474,61476,61478,61480,61483,61484,61486,61487,61489,61490,61492,61493,61494,61496,61497,61498,61502,61503,61750,61751,61758,61761,61763,61769,61772,61773,61776,61799,61800,61801,61804,61805,61807,61808,61809,61811,61812,61814,61815,61828,61829,61830,61833,61835,61836,61837,61865,61867,61868,61869,61870,61871,61872,61873,61899,61908,61909,61910,61911,61912,61920,61922,61930,61931,61932,61933,61936,61944,61948,61949,61950,61954,61957,61959,61960,61961,61962,61963,61964,61965,61966,61969,61970,61971,61972,61973,61975,61977,61979,61985,61986,61987,61988,61990,61991,61992,61997,61998,62011,62012,62014,63890,64616,64626,68431,69675,70000,71679,72608,72613,72614,72615,72616,72618,72640,72646,72655,72658,72667,72676,72679,72681,72689,72693,72728,72768,73431,73677,74002,74004,74008,74010,74012,74014,74016,74018,74020,74022,74024,74030,74032,74034,74036,74038,74042,74044,74046,74052,74054,74056,74058,74060,74062,74064,74066,74070,74072,74074,74584,74848,74850,74860,75257,75299,75364,75453,76439,77440,77693,77857,79499,80634,82611,87339,87458,87810,88286,88295,88301,88526,90477,90478,91482,94845,94846,95397,95558,95884,103902,104152,104460,104590,111548,113117,113118,113119,113248,113287,113291,113305,114444,115119,115357,115826,116776,116777,117578,118304,119138,123347,123773,124868,126523,126749,126757,126761,126762,126805,126855,128528,128531,128681,128940,128949,129237,129292,129969,131033,131230,132071,134597,135373,135374,135375,137062,137066,137068,137071,137882,138458,141446,141517,141645,142844,143173,143785,147232,147374,147375,147380,148130,148132,150083,150682,151982,154661,157943,159019,159149,161090,161105,162421,162430,162558,162575,163772,164722,168434,168435,169642,169896,170065,170068,170092,172360,172810,173169,173284,173285,173315,175161,179962,179963,181680,184163,184200,184524,188723,189400,189401,189402,189445,191761,191771,192359,192821,195872,196021,196205,196251,196410,196411,196626,199017,199100,199101,199102,199108,200368,202116,202119,202120,202489,202511,202799,203460,203923,203932,204258,204259,204260,204261,204263,204266,204267,204268,204275,204277,204278,204283,204290,204291,204292,204296,204298,204301,204302,204305,204306,204307,204308,204311,204312,204587,204597,204919,204933,204935,204936,206256,207360,207424,208918,208919,209582,209583,209586,209594,209595,209598,209603,209774,209776,209784,209802,209803,209804,209805,210127,210145,211820,213857,213858,213859,213861,215040,215092,215094,215965,216813,216814,216818,216829,216831,216832,216834,217367,217368,217369,217371,220531,221135,221136,221141,221146,222181,225438,225940,232161,232166,233207,245350,245525,245613,246827,247445,248323,248324,248325,248327,248330,248331,248332,248333,248344,249440,249447,249452,249455,249456,249469,249855,249938,249972,250104,250230,250231,250235,250345,250346,251061,251195,251820,252580,252622,252868,252869,252870,252871,252872,252873,252874,252875,252876,253049,253083,253403,253406,253407,253409,253410,253411,253412,253413,253415,253422,253423,253424,253427,253428,253439,253440,255035,255586,255875,255896,256417,256793,256885,260379,260633,260847,260929,261077,261834,262593,263368,263369,263706,263707,263708,264073,264074,264075,264379,264531,264690,266352,266382,266744,266745,266869,267071,267107,267629,267930,268035,268036,268920,269012,269013,269050,269082,269282,269285,269486,270541,270968,270976,271496,272141,272537,272646,272920,272921,273794,275674,276152,276914,277070,277253,277531,277582,277715,277840,278677,279532,280123,280770,280773,281014,281315,281711,281857,281922,282339,282827,282991,283521,283613,283684,284324,284417,284420,284606,284607,284943,285019,285551,286001,286327,286329,286955,286956,287428,288431,288786,290099,290101,290103,291267,292965,293364,294588,296450,297790,297791,297792,297793,297989,298289,298484,304861,305086,306775,306778,290132)

select distinct (dept) as dept from getproducts1 where brand='WINCHESTER AMMO' group by dept

select web_url, picture_id, web_taxonomy_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Ammo' and typ='EMPTY' and site = 'sportsman'

select distinct a.spec_value 
                                from 
                                    tb_mfg_promo.dbo.item_spec_values a 
                                left join 
                                    tb_web_taxonomy b on (a.spec_dept=b.web_taxonomy_id) 
                                left join 
                                    tb_mfg_promo.dbo.item_specs c on (a.spec_value_id=c.spec_value_id)
                                where 
                                    a.spec_dept = 2 and c.style_id in (217370,172271,204264,249454,199109,271776,61293,72688,127973,168795,298396,286697,256887,248328,72706,137599,61122,179833,61129,253425,161439,61417,304633,61294,253420,61396,162081,61943,169080,61472,102772,61418,61119,61945,175663,249451,61423,175667,248329,61355,114866,251197,266656,310056,310070,310071,310068,61220,199111,61968,204293,61328,129145,61426,61921,277298,61433,61874,61946,284144,61405,216839,216826,307980,137064,199107,61377,175664,285611,61379,61482,215089,61403,61431,74855,204294,61495,61357,61380,61481,61504,61875,61951,61967,127835,129290,204326,285128,61123,61131,61479,61810,61929,74026,199110,61080,61081,61111,61112,61113,61114,61118,61124,61125,61126,61127,61128,61130,61132,61133,61134,61136,61137,61139,61140,61142,61143,61144,61145,61146,61147,61148,61150,61153,61154,61155,61156,61157,61158,61161,61162,61163,61166,61167,61168,61169,61170,61172,61173,61175,61176,61177,61178,61184,61188,61195,61208,61216,61217,61219,61221,61225,61226,61228,61229,61230,61232,61237,61238,61239,61242,61267,61268,61269,61279,61280,61281,61285,61287,61288,61289,61290,61291,61292,61296,61299,61300,61301,61302,61303,61315,61317,61318,61319,61320,61321,61322,61324,61325,61326,61332,61334,61338,61343,61345,61348,61350,61353,61358,61359,61360,61362,61364,61365,61366,61367,61374,61375,61376,61378,61381,61382,61383,61384,61385,61386,61389,61391,61393,61394,61395,61397,61400,61402,61404,61410,61412,61419,61421,61424,61427,61429,61430,61435,61438,61439,61440,61442,61443,61445,61446,61447,61448,61449,61450,61451,61453,61454,61455,61458,61459,61460,61462,61463,61464,61465,61467,61468,61469,61474,61476,61478,61480,61483,61484,61486,61487,61489,61490,61492,61493,61494,61496,61497,61498,61502,61503,61750,61751,61758,61761,61763,61769,61772,61773,61776,61799,61800,61801,61804,61805,61807,61808,61809,61811,61812,61814,61815,61828,61829,61830,61833,61835,61836,61837,61865,61867,61868,61869,61870,61871,61872,61873,61899,61908,61909,61910,61911,61912,61920,61922,61930,61931,61932,61933,61936,61944,61948,61949,61950,61954,61957,61959,61960,61961,61962,61963,61964,61965,61966,61969,61970,61971,61972,61973,61975,61977,61979,61985,61986,61987,61988,61990,61991,61992,61997,61998,62011,62012,62014,63890,64616,64626,68431,69675,70000,71679,72608,72613,72614,72615,72616,72618,72640,72646,72655,72658,72667,72676,72679,72681,72689,72693,72728,72768,73431,73677,74002,74004,74008,74010,74012,74014,74016,74018,74020,74022,74024,74030,74032,74034,74036,74038,74042,74044,74046,74052,74054,74056,74058,74060,74062,74064,74066,74070,74072,74074,74584,74848,74850,74860,75257,75299,75364,75453,76439,77440,77693,77857,79499,80634,82611,87339,87458,87810,88286,88295,88301,88526,90477,90478,91482,94845,94846,95397,95558,95884,103902,104152,104460,104590,111548,113117,113118,113119,113248,113287,113291,113305,114444,115119,115357,115826,116776,116777,117578,118304,119138,123347,123773,124868,126523,126749,126757,126761,126762,126805,126855,128528,128531,128681,128940,128949,129237,129292,129969,131033,131230,132071,134597,135373,135374,135375,137062,137066,137068,137071,137882,138458,141446,141517,141645,142844,143173,143785,147232,147374,147375,147380,148130,148132,150083,150682,151982,154661,157943,159019,159149,161090,161105,162421,162430,162558,162575,163772,164722,168434,168435,169642,169896,170065,170068,170092,172360,172810,173169,173284,173285,173315,175161,179962,179963,181680,184163,184200,184524,188723,189400,189401,189402,189445,191761,191771,192359,192821,195872,196021,196205,196251,196410,196411,196626,199017,199100,199101,199102,199108,200368,202116,202119,202120,202489,202511,202799,203460,203923,203932,204258,204259,204260,204261,204263,204266,204267,204268,204275,204277,204278,204283,204290,204291,204292,204296,204298,204301,204302,204305,204306,204307,204308,204311,204312,204587,204597,204919,204933,204935,204936,206256,207360,207424,208918,208919,209582,209583,209586,209594,209595,209598,209603,209774,209776,209784,209802,209803,209804,209805,210127,210145,211820,213857,213858,213859,213861,215040,215092,215094,215965,216813,216814,216818,216829,216831,216832,216834,217367,217368,217369,217371,220531,221135,221136,221141,221146,222181,225438,225940,232161,232166,233207,245350,245525,245613,246827,247445,248323,248324,248325,248327,248330,248331,248332,248333,248344,249440,249447,249452,249455,249456,249469,249855,249938,249972,250104,250230,250231,250235,250345,250346,251061,251195,251820,252580,252622,252868,252869,252870,252871,252872,252873,252874,252875,252876,253049,253083,253403,253406,253407,253409,253410,253411,253412,253413,253415,253422,253423,253424,253427,253428,253439,253440,255035,255586,255875,255896,256417,256793,256885,260379,260633,260847,260929,261077,261834,262593,263368,263369,263706,263707,263708,264073,264074,264075,264379,264531,264690,266352,266382,266744,266745,266869,267071,267107,267629,267930,268035,268036,268920,269012,269013,269050,269082,269282,269285,269486,270541,270968,270976,271496,272141,272537,272646,272920,272921,273794,275674,276152,276914,277070,277253,277531,277582,277715,277840,278677,279532,280123,280770,280773,281014,281315,281711,281857,281922,282339,282827,282991,283521,283613,283684,284324,284417,284420,284606,284607,284943,285019,285551,286001,286327,286329,286955,286956,287428,288431,288786,290099,290101,290103,291267,292965,293364,294588,296450,297790,297791,297792,297793,297989,298289,298484,304861,305086,306775,306778,290132)

select distinct typ from getproducts1 where dept='Ammo' and brand='WINCHESTER AMMO' group by typ order by sort_position

select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Ammo' and typ='Handgun Ammunition' and subtyp_1='EMPTY' and site = 'sportsman'

select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Ammo' and typ='Rifle Ammunition' and subtyp_1='EMPTY' and site = 'sportsman'

select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Ammo' and typ='Rimfire Ammunition' and subtyp_1='EMPTY' and site = 'sportsman'

select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Ammo' and typ='Shotgun Ammunition' and subtyp_1='EMPTY' and site = 'sportsman'

select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Ammo' and typ='Vintage and Police Trade Ammo' and subtyp_1='EMPTY' and site = 'sportsman'

select web_url, picture_id, web_taxonomy_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Law Enforcement' and typ='EMPTY' and site = 'sportsman'

select distinct a.spec_value 
                                from 
                                    tb_mfg_promo.dbo.item_spec_values a 
                                left join 
                                    tb_web_taxonomy b on (a.spec_dept=b.web_taxonomy_id) 
                                left join 
                                    tb_mfg_promo.dbo.item_specs c on (a.spec_value_id=c.spec_value_id)
                                where 
                                    a.spec_dept = 29 and c.style_id in (217370,172271,204264,249454,199109,271776,61293,72688,127973,168795,298396,286697,256887,248328,72706,137599,61122,179833,61129,253425,161439,61417,304633,61294,253420,61396,162081,61943,169080,61472,102772,61418,61119,61945,175663,249451,61423,175667,248329,61355,114866,251197,266656,310056,310070,310071,310068,61220,199111,61968,204293,61328,129145,61426,61921,277298,61433,61874,61946,284144,61405,216839,216826,307980,137064,199107,61377,175664,285611,61379,61482,215089,61403,61431,74855,204294,61495,61357,61380,61481,61504,61875,61951,61967,127835,129290,204326,285128,61123,61131,61479,61810,61929,74026,199110,61080,61081,61111,61112,61113,61114,61118,61124,61125,61126,61127,61128,61130,61132,61133,61134,61136,61137,61139,61140,61142,61143,61144,61145,61146,61147,61148,61150,61153,61154,61155,61156,61157,61158,61161,61162,61163,61166,61167,61168,61169,61170,61172,61173,61175,61176,61177,61178,61184,61188,61195,61208,61216,61217,61219,61221,61225,61226,61228,61229,61230,61232,61237,61238,61239,61242,61267,61268,61269,61279,61280,61281,61285,61287,61288,61289,61290,61291,61292,61296,61299,61300,61301,61302,61303,61315,61317,61318,61319,61320,61321,61322,61324,61325,61326,61332,61334,61338,61343,61345,61348,61350,61353,61358,61359,61360,61362,61364,61365,61366,61367,61374,61375,61376,61378,61381,61382,61383,61384,61385,61386,61389,61391,61393,61394,61395,61397,61400,61402,61404,61410,61412,61419,61421,61424,61427,61429,61430,61435,61438,61439,61440,61442,61443,61445,61446,61447,61448,61449,61450,61451,61453,61454,61455,61458,61459,61460,61462,61463,61464,61465,61467,61468,61469,61474,61476,61478,61480,61483,61484,61486,61487,61489,61490,61492,61493,61494,61496,61497,61498,61502,61503,61750,61751,61758,61761,61763,61769,61772,61773,61776,61799,61800,61801,61804,61805,61807,61808,61809,61811,61812,61814,61815,61828,61829,61830,61833,61835,61836,61837,61865,61867,61868,61869,61870,61871,61872,61873,61899,61908,61909,61910,61911,61912,61920,61922,61930,61931,61932,61933,61936,61944,61948,61949,61950,61954,61957,61959,61960,61961,61962,61963,61964,61965,61966,61969,61970,61971,61972,61973,61975,61977,61979,61985,61986,61987,61988,61990,61991,61992,61997,61998,62011,62012,62014,63890,64616,64626,68431,69675,70000,71679,72608,72613,72614,72615,72616,72618,72640,72646,72655,72658,72667,72676,72679,72681,72689,72693,72728,72768,73431,73677,74002,74004,74008,74010,74012,74014,74016,74018,74020,74022,74024,74030,74032,74034,74036,74038,74042,74044,74046,74052,74054,74056,74058,74060,74062,74064,74066,74070,74072,74074,74584,74848,74850,74860,75257,75299,75364,75453,76439,77440,77693,77857,79499,80634,82611,87339,87458,87810,88286,88295,88301,88526,90477,90478,91482,94845,94846,95397,95558,95884,103902,104152,104460,104590,111548,113117,113118,113119,113248,113287,113291,113305,114444,115119,115357,115826,116776,116777,117578,118304,119138,123347,123773,124868,126523,126749,126757,126761,126762,126805,126855,128528,128531,128681,128940,128949,129237,129292,129969,131033,131230,132071,134597,135373,135374,135375,137062,137066,137068,137071,137882,138458,141446,141517,141645,142844,143173,143785,147232,147374,147375,147380,148130,148132,150083,150682,151982,154661,157943,159019,159149,161090,161105,162421,162430,162558,162575,163772,164722,168434,168435,169642,169896,170065,170068,170092,172360,172810,173169,173284,173285,173315,175161,179962,179963,181680,184163,184200,184524,188723,189400,189401,189402,189445,191761,191771,192359,192821,195872,196021,196205,196251,196410,196411,196626,199017,199100,199101,199102,199108,200368,202116,202119,202120,202489,202511,202799,203460,203923,203932,204258,204259,204260,204261,204263,204266,204267,204268,204275,204277,204278,204283,204290,204291,204292,204296,204298,204301,204302,204305,204306,204307,204308,204311,204312,204587,204597,204919,204933,204935,204936,206256,207360,207424,208918,208919,209582,209583,209586,209594,209595,209598,209603,209774,209776,209784,209802,209803,209804,209805,210127,210145,211820,213857,213858,213859,213861,215040,215092,215094,215965,216813,216814,216818,216829,216831,216832,216834,217367,217368,217369,217371,220531,221135,221136,221141,221146,222181,225438,225940,232161,232166,233207,245350,245525,245613,246827,247445,248323,248324,248325,248327,248330,248331,248332,248333,248344,249440,249447,249452,249455,249456,249469,249855,249938,249972,250104,250230,250231,250235,250345,250346,251061,251195,251820,252580,252622,252868,252869,252870,252871,252872,252873,252874,252875,252876,253049,253083,253403,253406,253407,253409,253410,253411,253412,253413,253415,253422,253423,253424,253427,253428,253439,253440,255035,255586,255875,255896,256417,256793,256885,260379,260633,260847,260929,261077,261834,262593,263368,263369,263706,263707,263708,264073,264074,264075,264379,264531,264690,266352,266382,266744,266745,266869,267071,267107,267629,267930,268035,268036,268920,269012,269013,269050,269082,269282,269285,269486,270541,270968,270976,271496,272141,272537,272646,272920,272921,273794,275674,276152,276914,277070,277253,277531,277582,277715,277840,278677,279532,280123,280770,280773,281014,281315,281711,281857,281922,282339,282827,282991,283521,283613,283684,284324,284417,284420,284606,284607,284943,285019,285551,286001,286327,286329,286955,286956,287428,288431,288786,290099,290101,290103,291267,292965,293364,294588,296450,297790,297791,297792,297793,297989,298289,298484,304861,305086,306775,306778,290132)

select distinct typ from getproducts1 where dept='Law Enforcement' and brand='WINCHESTER AMMO' group by typ order by sort_position

select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Law Enforcement' and typ='Law Enforcement Ammo' and subtyp_1='EMPTY' and site = 'sportsman'

select web_url, picture_id, web_taxonomy_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Reloading' and typ='EMPTY' and site = 'sportsman'

select distinct a.spec_value 
                                from 
                                    tb_mfg_promo.dbo.item_spec_values a 
                                left join 
                                    tb_web_taxonomy b on (a.spec_dept=b.web_taxonomy_id) 
                                left join 
                                    tb_mfg_promo.dbo.item_specs c on (a.spec_value_id=c.spec_value_id)
                                where 
                                    a.spec_dept = 958 and c.style_id in (217370,172271,204264,249454,199109,271776,61293,72688,127973,168795,298396,286697,256887,248328,72706,137599,61122,179833,61129,253425,161439,61417,304633,61294,253420,61396,162081,61943,169080,61472,102772,61418,61119,61945,175663,249451,61423,175667,248329,61355,114866,251197,266656,310056,310070,310071,310068,61220,199111,61968,204293,61328,129145,61426,61921,277298,61433,61874,61946,284144,61405,216839,216826,307980,137064,199107,61377,175664,285611,61379,61482,215089,61403,61431,74855,204294,61495,61357,61380,61481,61504,61875,61951,61967,127835,129290,204326,285128,61123,61131,61479,61810,61929,74026,199110,61080,61081,61111,61112,61113,61114,61118,61124,61125,61126,61127,61128,61130,61132,61133,61134,61136,61137,61139,61140,61142,61143,61144,61145,61146,61147,61148,61150,61153,61154,61155,61156,61157,61158,61161,61162,61163,61166,61167,61168,61169,61170,61172,61173,61175,61176,61177,61178,61184,61188,61195,61208,61216,61217,61219,61221,61225,61226,61228,61229,61230,61232,61237,61238,61239,61242,61267,61268,61269,61279,61280,61281,61285,61287,61288,61289,61290,61291,61292,61296,61299,61300,61301,61302,61303,61315,61317,61318,61319,61320,61321,61322,61324,61325,61326,61332,61334,61338,61343,61345,61348,61350,61353,61358,61359,61360,61362,61364,61365,61366,61367,61374,61375,61376,61378,61381,61382,61383,61384,61385,61386,61389,61391,61393,61394,61395,61397,61400,61402,61404,61410,61412,61419,61421,61424,61427,61429,61430,61435,61438,61439,61440,61442,61443,61445,61446,61447,61448,61449,61450,61451,61453,61454,61455,61458,61459,61460,61462,61463,61464,61465,61467,61468,61469,61474,61476,61478,61480,61483,61484,61486,61487,61489,61490,61492,61493,61494,61496,61497,61498,61502,61503,61750,61751,61758,61761,61763,61769,61772,61773,61776,61799,61800,61801,61804,61805,61807,61808,61809,61811,61812,61814,61815,61828,61829,61830,61833,61835,61836,61837,61865,61867,61868,61869,61870,61871,61872,61873,61899,61908,61909,61910,61911,61912,61920,61922,61930,61931,61932,61933,61936,61944,61948,61949,61950,61954,61957,61959,61960,61961,61962,61963,61964,61965,61966,61969,61970,61971,61972,61973,61975,61977,61979,61985,61986,61987,61988,61990,61991,61992,61997,61998,62011,62012,62014,63890,64616,64626,68431,69675,70000,71679,72608,72613,72614,72615,72616,72618,72640,72646,72655,72658,72667,72676,72679,72681,72689,72693,72728,72768,73431,73677,74002,74004,74008,74010,74012,74014,74016,74018,74020,74022,74024,74030,74032,74034,74036,74038,74042,74044,74046,74052,74054,74056,74058,74060,74062,74064,74066,74070,74072,74074,74584,74848,74850,74860,75257,75299,75364,75453,76439,77440,77693,77857,79499,80634,82611,87339,87458,87810,88286,88295,88301,88526,90477,90478,91482,94845,94846,95397,95558,95884,103902,104152,104460,104590,111548,113117,113118,113119,113248,113287,113291,113305,114444,115119,115357,115826,116776,116777,117578,118304,119138,123347,123773,124868,126523,126749,126757,126761,126762,126805,126855,128528,128531,128681,128940,128949,129237,129292,129969,131033,131230,132071,134597,135373,135374,135375,137062,137066,137068,137071,137882,138458,141446,141517,141645,142844,143173,143785,147232,147374,147375,147380,148130,148132,150083,150682,151982,154661,157943,159019,159149,161090,161105,162421,162430,162558,162575,163772,164722,168434,168435,169642,169896,170065,170068,170092,172360,172810,173169,173284,173285,173315,175161,179962,179963,181680,184163,184200,184524,188723,189400,189401,189402,189445,191761,191771,192359,192821,195872,196021,196205,196251,196410,196411,196626,199017,199100,199101,199102,199108,200368,202116,202119,202120,202489,202511,202799,203460,203923,203932,204258,204259,204260,204261,204263,204266,204267,204268,204275,204277,204278,204283,204290,204291,204292,204296,204298,204301,204302,204305,204306,204307,204308,204311,204312,204587,204597,204919,204933,204935,204936,206256,207360,207424,208918,208919,209582,209583,209586,209594,209595,209598,209603,209774,209776,209784,209802,209803,209804,209805,210127,210145,211820,213857,213858,213859,213861,215040,215092,215094,215965,216813,216814,216818,216829,216831,216832,216834,217367,217368,217369,217371,220531,221135,221136,221141,221146,222181,225438,225940,232161,232166,233207,245350,245525,245613,246827,247445,248323,248324,248325,248327,248330,248331,248332,248333,248344,249440,249447,249452,249455,249456,249469,249855,249938,249972,250104,250230,250231,250235,250345,250346,251061,251195,251820,252580,252622,252868,252869,252870,252871,252872,252873,252874,252875,252876,253049,253083,253403,253406,253407,253409,253410,253411,253412,253413,253415,253422,253423,253424,253427,253428,253439,253440,255035,255586,255875,255896,256417,256793,256885,260379,260633,260847,260929,261077,261834,262593,263368,263369,263706,263707,263708,264073,264074,264075,264379,264531,264690,266352,266382,266744,266745,266869,267071,267107,267629,267930,268035,268036,268920,269012,269013,269050,269082,269282,269285,269486,270541,270968,270976,271496,272141,272537,272646,272920,272921,273794,275674,276152,276914,277070,277253,277531,277582,277715,277840,278677,279532,280123,280770,280773,281014,281315,281711,281857,281922,282339,282827,282991,283521,283613,283684,284324,284417,284420,284606,284607,284943,285019,285551,286001,286327,286329,286955,286956,287428,288431,288786,290099,290101,290103,291267,292965,293364,294588,296450,297790,297791,297792,297793,297989,298289,298484,304861,305086,306775,306778,290132)

select distinct typ from getproducts1 where dept='Reloading' and brand='WINCHESTER AMMO' group by typ order by sort_position

select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Reloading' and typ='Brass Cases' and subtyp_1='EMPTY' and site = 'sportsman'

select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Reloading' and typ='Bullets' and subtyp_1='EMPTY' and site = 'sportsman'

select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Reloading' and typ='Primers' and subtyp_1='EMPTY' and site = 'sportsman'

select web_url from tb_web_taxonomy with (nolock) where dept='' and site = 'sportsman'

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
			from tb_skus a with (nolock)
			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
			where a.style_id = 61462 and e.store_id = 10 
			group by a.style_id, e.qc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 61462 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

select * from bulkitems where bulk_id = ? and site is NULL

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 15:11:48' and
end_date >= 'May 20, 2024 15:11:48'
and store_id=10 and style_id=61462

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 61462 
and (a.start_date<= 'May 20, 2024 15:11:48' or a.active = 1)
and a.end_date >= 'May 20, 2024 15:11:48'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=61462  and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=61462 and status='A' and site = 'sportsman'

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
			from tb_skus a with (nolock)
			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
			where a.style_id = 61463 and e.store_id = 10 
			group by a.style_id, e.qc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 61463 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

select * from bulkitems where bulk_id = ? and site is NULL

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 15:11:48' and
end_date >= 'May 20, 2024 15:11:48'
and store_id=10 and style_id=61463

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 61463 
and (a.start_date<= 'May 20, 2024 15:11:48' or a.active = 1)
and a.end_date >= 'May 20, 2024 15:11:48'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=61463  and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=61463 and status='A' and site = 'sportsman'

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
			from tb_skus a with (nolock)
			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
			where a.style_id = 61464 and e.store_id = 10 
			group by a.style_id, e.qc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 61464 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

select * from bulkitems where bulk_id = ? and site is NULL

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 15:11:48' and
end_date >= 'May 20, 2024 15:11:48'
and store_id=10 and style_id=61464

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 61464 
and (a.start_date<= 'May 20, 2024 15:11:48' or a.active = 1)
and a.end_date >= 'May 20, 2024 15:11:48'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=61464  and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=61464 and status='A' and site = 'sportsman'

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
			from tb_skus a with (nolock)
			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
			where a.style_id = 61465 and e.store_id = 10 
			group by a.style_id, e.qc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 61465 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

select * from bulkitems where bulk_id = ? and site is NULL

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 15:11:48' and
end_date >= 'May 20, 2024 15:11:48'
and store_id=10 and style_id=61465

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 61465 
and (a.start_date<= 'May 20, 2024 15:11:48' or a.active = 1)
and a.end_date >= 'May 20, 2024 15:11:48'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=61465  and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=61465 and status='A' and site = 'sportsman'

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
			from tb_skus a with (nolock)
			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
			where a.style_id = 61467 and e.store_id = 10 
			group by a.style_id, e.qc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 61467 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

select * from bulkitems where bulk_id = ? and site is NULL

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 15:11:48' and
end_date >= 'May 20, 2024 15:11:48'
and store_id=10 and style_id=61467

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 61467 
and (a.start_date<= 'May 20, 2024 15:11:48' or a.active = 1)
and a.end_date >= 'May 20, 2024 15:11:48'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=61467  and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=61467 and status='A' and site = 'sportsman'

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
			from tb_skus a with (nolock)
			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
			where a.style_id = 61468 and e.store_id = 10 
			group by a.style_id, e.qc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 61468 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

select * from bulkitems where bulk_id = ? and site is NULL

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 15:11:48' and
end_date >= 'May 20, 2024 15:11:48'
and store_id=10 and style_id=61468

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 61468 
and (a.start_date<= 'May 20, 2024 15:11:48' or a.active = 1)
and a.end_date >= 'May 20, 2024 15:11:48'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=61468  and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=61468 and status='A' and site = 'sportsman'

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
			from tb_skus a with (nolock)
			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
			where a.style_id = 61469 and e.store_id = 10 
			group by a.style_id, e.qc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 61469 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

select * from bulkitems where bulk_id = ? and site is NULL

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 15:11:48' and
end_date >= 'May 20, 2024 15:11:48'
and store_id=10 and style_id=61469

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 61469 
and (a.start_date<= 'May 20, 2024 15:11:48' or a.active = 1)
and a.end_date >= 'May 20, 2024 15:11:48'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=61469  and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=61469 and status='A' and site = 'sportsman'

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
			from tb_skus a with (nolock)
			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
			where a.style_id = 61474 and e.store_id = 10 
			group by a.style_id, e.qc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 61474 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

select * from bulkitems where bulk_id = ? and site is NULL

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 15:11:48' and
end_date >= 'May 20, 2024 15:11:48'
and store_id=10 and style_id=61474

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 61474 
and (a.start_date<= 'May 20, 2024 15:11:48' or a.active = 1)
and a.end_date >= 'May 20, 2024 15:11:48'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=61474  and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=61474 and status='A' and site = 'sportsman'

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
			from tb_skus a with (nolock)
			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
			where a.style_id = 61476 and e.store_id = 10 
			group by a.style_id, e.qc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 61476 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

select * from bulkitems where bulk_id = ? and site is NULL

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 15:11:48' and
end_date >= 'May 20, 2024 15:11:48'
and store_id=10 and style_id=61476

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 61476 
and (a.start_date<= 'May 20, 2024 15:11:48' or a.active = 1)
and a.end_date >= 'May 20, 2024 15:11:48'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=61476  and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=61476 and status='A' and site = 'sportsman'

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
			from tb_skus a with (nolock)
			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
			where a.style_id = 61478 and e.store_id = 10 
			group by a.style_id, e.qc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 61478 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

select * from bulkitems where bulk_id = ? and site is NULL

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 15:11:48' and
end_date >= 'May 20, 2024 15:11:48'
and store_id=10 and style_id=61478

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 61478 
and (a.start_date<= 'May 20, 2024 15:11:48' or a.active = 1)
and a.end_date >= 'May 20, 2024 15:11:48'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=61478  and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=61478 and status='A' and site = 'sportsman'

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
			from tb_skus a with (nolock)
			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
			where a.style_id = 61480 and e.store_id = 10 
			group by a.style_id, e.qc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 61480 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

select * from bulkitems where bulk_id = ? and site is NULL

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 15:11:48' and
end_date >= 'May 20, 2024 15:11:48'
and store_id=10 and style_id=61480

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 61480 
and (a.start_date<= 'May 20, 2024 15:11:48' or a.active = 1)
and a.end_date >= 'May 20, 2024 15:11:48'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=61480  and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=61480 and status='A' and site = 'sportsman'

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
			from tb_skus a with (nolock)
			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
			where a.style_id = 61483 and e.store_id = 10 
			group by a.style_id, e.qc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 61483 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

select * from bulkitems where bulk_id = ? and site is NULL

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 15:11:48' and
end_date >= 'May 20, 2024 15:11:48'
and store_id=10 and style_id=61483

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 61483 
and (a.start_date<= 'May 20, 2024 15:11:48' or a.active = 1)
and a.end_date >= 'May 20, 2024 15:11:48'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=61483  and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=61483 and status='A' and site = 'sportsman'

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
			from tb_skus a with (nolock)
			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
			where a.style_id = 61484 and e.store_id = 10 
			group by a.style_id, e.qc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 61484 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

select * from bulkitems where bulk_id = ? and site is NULL

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 15:11:48' and
end_date >= 'May 20, 2024 15:11:48'
and store_id=10 and style_id=61484

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 61484 
and (a.start_date<= 'May 20, 2024 15:11:48' or a.active = 1)
and a.end_date >= 'May 20, 2024 15:11:48'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=61484  and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=61484 and status='A' and site = 'sportsman'

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
			from tb_skus a with (nolock)
			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
			where a.style_id = 61486 and e.store_id = 10 
			group by a.style_id, e.qc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 61486 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

select * from bulkitems where bulk_id = ? and site is NULL

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 15:11:48' and
end_date >= 'May 20, 2024 15:11:48'
and store_id=10 and style_id=61486

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 61486 
and (a.start_date<= 'May 20, 2024 15:11:48' or a.active = 1)
and a.end_date >= 'May 20, 2024 15:11:48'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=61486  and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=61486 and status='A' and site = 'sportsman'

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
			from tb_skus a with (nolock)
			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
			where a.style_id = 61487 and e.store_id = 10 
			group by a.style_id, e.qc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 61487 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

select * from bulkitems where bulk_id = ? and site is NULL

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 15:11:48' and
end_date >= 'May 20, 2024 15:11:48'
and store_id=10 and style_id=61487

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 61487 
and (a.start_date<= 'May 20, 2024 15:11:48' or a.active = 1)
and a.end_date >= 'May 20, 2024 15:11:48'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=61487  and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=61487 and status='A' and site = 'sportsman'

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
			from tb_skus a with (nolock)
			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
			where a.style_id = 61489 and e.store_id = 10 
			group by a.style_id, e.qc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 61489 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

select * from bulkitems where bulk_id = ? and site is NULL

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 15:11:48' and
end_date >= 'May 20, 2024 15:11:48'
and store_id=10 and style_id=61489

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 61489 
and (a.start_date<= 'May 20, 2024 15:11:48' or a.active = 1)
and a.end_date >= 'May 20, 2024 15:11:48'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=61489  and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=61489 and status='A' and site = 'sportsman'

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
			from tb_skus a with (nolock)
			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
			where a.style_id = 61490 and e.store_id = 10 
			group by a.style_id, e.qc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 61490 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

select * from bulkitems where bulk_id = ? and site is NULL

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 15:11:49' and
end_date >= 'May 20, 2024 15:11:49'
and store_id=10 and style_id=61490

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 61490 
and (a.start_date<= 'May 20, 2024 15:11:49' or a.active = 1)
and a.end_date >= 'May 20, 2024 15:11:49'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=61490  and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=61490 and status='A' and site = 'sportsman'

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
			from tb_skus a with (nolock)
			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
			where a.style_id = 61492 and e.store_id = 10 
			group by a.style_id, e.qc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 61492 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

select * from bulkitems where bulk_id = ? and site is NULL

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 15:11:49' and
end_date >= 'May 20, 2024 15:11:49'
and store_id=10 and style_id=61492

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 61492 
and (a.start_date<= 'May 20, 2024 15:11:49' or a.active = 1)
and a.end_date >= 'May 20, 2024 15:11:49'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=61492  and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=61492 and status='A' and site = 'sportsman'

Application Variables:
acceptorid=011668467
accountid=1027380
accounttoken=64BB6980FDEAF842266AC866F250CA9877FF24AE92795FB9BE490EAF527645FC4E54DC01
adminurl=https://www.sportsmansoutdoorsuperstore.com/web_admin/products/menu.cfm?style_id=
applicationname=SOS
bannerurl=https://www.sportsmansoutdoorsuperstore.com/images/banners/
ccprocessor=VANTIV
checkinventory=Struct (3)
companyname=Vance Outdoors
credova=Struct (5)
ds=celerantsql
enter_inscription=OFF
feedsdir=E:\inetpub\feeds\
forumemail=info@sportsmansoutdoorsuperstore.com
forumtitle=Sportsmans Outdoor Superstore
giftcardimgpath=file:///C:/websites/images/
giftcardpdfpath=E:\websites\giftcardPDF\
googlefeedproducttype=
homeurl=https://www.sportsmansoutdoorsuperstore.com/
hostedpagelink=https://transaction.hostedpayments.com/
iconurl=https://www.sportsmansoutdoorsuperstore.com/images/icons/
imagedir=E:\inetpub\images\
logdir=E:\inetpub\logs
metadesc=
metatags=
mydomain=https://www.sportsmansoutdoorsuperstore.com/
pagetitle=
picurl=https://www.sportsmansoutdoorsuperstore.com/images/
prodimgdir=E:\inetpub\prodimages\
prodimgurl=https://www.sportsmansoutdoorsuperstore.com/prodimages/
qoh_store=10
safety_stock=0
salesemail=sales@sportsmansoutdoorsuperstore.com
secureurl=https://www.sportsmansoutdoorsuperstore.com/
site=sportsman
tempmailport=25
tempmailserver=127.0.0.1
tokenurl=https://services.elementexpress.com/express.asmx
use_multi_buy=OFF
vantivurl=https://transaction.elementexpress.com/express.asmx
webadminurl=https://www.sportsmansoutdoorsuperstore.com/web_admin/
websitename=Sportsmans Outdoor Superstore

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=256
CERT_SECRETKEYSIZE=2048
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=C=US, O=Let's Encrypt, CN=R3
CERT_SERVER_SUBJECT=CN=www.sportsmansoutdoorsuperstore.com
CERT_SUBJECT=
CF_TEMPLATE_PATH=E:\inetpub\wwwroot\category.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=on
HTTPS_KEYSIZE=256
HTTPS_SECRETKEYSIZE=2048
HTTPS_SERVER_ISSUER=C=US, O=Let's Encrypt, CN=R3
HTTPS_SERVER_SUBJECT=CN=www.sportsmansoutdoorsuperstore.com
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br, zstd, deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=close
HTTP_COOKIE=CFGLOBALS=urltoken%3DCFID%23%3D12753%26CFTOKEN%23%3D1c4d342fd6495c7e%2DEA2A66A4%2DCFBF%2DC554%2DA293F0DF44349D8F%23lastvisit%3D%7Bts%20%272024%2D05%2D20%2015%3A11%3A47%27%7D%23hitcount%3D19%23timecreated%3D%7Bts%20%272024%2D05%2D20%2015%3A11%3A39%27%7D%23cftoken%3D1c4d342fd6495c7e%2DEA2A66A4%2DCFBF%2DC554%2DA293F0DF44349D8F%23cfid%3D12753%23; CFTOKEN=Z98olbwg5rxrj4kxa625akg5dpmaa354uo66g173yqvk4tox9o-1c4d342fd6495c7e-EA2A66A4-CFBF-C554-A293F0DF44349D8F; CFID=Z98olbwg5rxrj4kxa625akg5dpmaa354uo66g173yqvk4tox9o-12753; USERNAME=; CUSTOMER_ID=; CT_U=2987; EMAIL=; FIRST_NAME=; LAST_NAME=; PASSWORD=; PRD_U=262699%2C918
HTTP_HOST=www.sportsmansoutdoorsuperstore.com
HTTP_REFERER=
HTTP_URL=/category.cfm/CurrentPage/15/sportsman/EMPTY/brand/WINCHESTER%20AMMO
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=10.200.30.6
PATH_INFO=/CurrentPage/15/sportsman/EMPTY/brand/WINCHESTER AMMO
PATH_TRANSLATED=E:\inetpub\wwwroot\category.cfm
QUERY_STRING=
REMOTE_ADDR=10.200.2.4
REMOTE_HOST=10.200.2.4
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/category.cfm
SERVER_NAME=www.sportsmansoutdoorsuperstore.com
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=

Client Variables:
cfid=12753
cftoken=1c4d342fd6495c7e-EA2A66A4-CFBF-C554-A293F0DF44349D8F
hitcount=19
lastvisit={ts '2024-05-20 15:11:47'}
timecreated={ts '2024-05-20 15:11:39'}
urltoken=CFID=12753&CFTOKEN=1c4d342fd6495c7e-EA2A66A4-CFBF-C554-A293F0DF44349D8F

Cookie Variables:
CFGLOBALS=urltoken=CFID#=12753&CFTOKEN#=1c4d342fd6495c7e-EA2A66A4-CFBF-C554-A293F0DF44349D8F#lastvisit={ts '2024-05-20 15:11:47'}#hitcount=19#timecreated={ts '2024-05-20 15:11:39'}#cftoken=1c4d342fd6495c7e-EA2A66A4-CFBF-C554-A293F0DF44349D8F#cfid=12753#
CFID=12753
CFTOKEN=1c4d342fd6495c7e-EA2A66A4-CFBF-C554-A293F0DF44349D8F
CT_U=2987
CUSTOMER_ID=
EMAIL=
FIRST_NAME=
LAST_NAME=
PASSWORD=
PRD_U=262699,918
USERNAME=

Form Fields:
RETURN_TO_PAGE=null

Request Parameters:
samesite_value=

Server Variables:
coldfusion=Struct (10)
os=Struct (5)
system=Struct (2)

Session Variables:
cfid=12753
cftoken=1c4d342fd6495c7e-EA2A66A4-CFBF-C554-A293F0DF44349D8F
cs=/category.cfm/CurrentPage/15/sportsman/EMPTY/brand/WINCHESTER AMMO
displaycount=18
employeeloggedin=N
fflnote=
firearm_agreement=NO
imgarray=Array (0)
memberloggedin=N
pickupstore=10
prodtype=none
selected_ffl=NO
sessionid=SOS_12753_1c4d342fd6495c7e-EA2A66A4-CFBF-C554-A293F0DF44349D8F
strarray=Array (0)
urltoken=CFID=12753&CFTOKEN=1c4d342fd6495c7e-EA2A66A4-CFBF-C554-A293F0DF44349D8F

URL Parameters:
CLEARANCE=
CurrentPage=15
DEPT=
NAV_CHOOSER=
OF1=
OF10=
OF2=
OF3=
OF4=
OF5=
OF6=
ORDER_BY=
PAGETYPE=
PRODTYPE=none
RETURN_TO_PAGE=null
SECTION=
SUBTYP_1=
SUBTYP_2=
SUBTYP_3=
TYP=
WEB_TAXONOMY_ID=
WHATSNEW=
brand=WINCHESTER AMMO
sportsman=EMPTY